Round 1 - Technical (𝟰𝟱 𝗺𝗶𝗻𝘀)

🔹Write a SQL query to retrieve data from a database.

🔹Implement a Python function to manipulate data or solve basic algorithm problems.

🔹Optimize SQL queries for time and space complexity.

🔹Random based on resume.

Round 2 - Technical (𝟰𝟱 𝗺𝗶𝗻𝘀)

🔹Write a SQL query to calculate the average salary of employees by department.

🔹Implement a Python function to find a unique element in a sorted array.

🔹Discuss your previous projects, challenges faced, and solutions implemented.

Round 3 - 𝗦𝘆𝘀𝘁𝗲𝗺 𝗱𝗲𝘀𝗶𝗴𝗻 (60 𝗺𝗶𝗻𝘀)

🔹Design a data pipeline to ingest livestream data.

🔹Propose a scalable data processing pipeline for analyzing large IoT datasets.

Round 4 - Manager

🔹Project Experience and Problem-Solving

🔹Behavioral Insights

🔹Discuss strategies for cross-AZ data transfer, including optimization for low latency, fault tolerance, encryption, and access control for data security.

🔹Highlight key Spark optimizations, including partitioning, caching, join optimization, memory tuning, and reducing shuffle overhead for performance improvements.